Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# CREATE_STORED_OUTLINES

Property | Description
--- | ---
Parameter type | String
Syntax | `CREATE_STORED_OUTLINES = { true | false |` `category_name` `}`
Default value | There is no default value.
Modifiable | `ALTER SESSION`, `ALTER SYSTEM`
Basic | No

`CREATE_STORED_OUTLINES` determines whether Oracle automatically creates and stores an outline for each query submitted during the session.

Values:

- `true`

  Enables automatic outline creation for subsequent queries in the same session. These outlines receive a unique system-generated name and are stored in the `DEFAULT` category. If a particular query already has an outline defined for it in the `DEFAULT` category, then that outline will remain and a new outline will not be created.

- `false`

  Disables automatic outline creation during the session. This is the default.

- `category_name`

  Enables the same behavior as `true` except that any outline created during the session is stored in the `category_name` category.

  See Also: Oracle Database Performance Tuning Guide for more information on setting this parameter